1 import sqlite3
2
3 def connect():
4 conn = sqlite3.connect("student.db")
5 cur = conn.cursor()
6
7 cur.execute("CREATE TABLE IF NOT EXISTS student (id INTEGER PRIMARY KEY, name text, fname text, mname text, \
8 address text, mobno integer,email text, dob integer, gender text)")
9
10 conn.commit()
11 conn.close()
12
13 def insert(name = " ", fname = " ", mname = " ", address = " ", mobno = " ", email = " ", dob = " ", gender = " "):
14 conn = sqlite3.connect("student.db")
15 cur = conn.cursor()
16
17 cur.execute("INSERT INTO student VALUES (NULL,?,?,?,?,?,?,?,?)", (name, fname, mname, address , mobno, email, dob, gender))
18
19 conn.commit()
20 conn.close()
21
22
23 def view():
24 conn = sqlite3.connect("student.db")
25 cur = conn.cursor()
26
27 cur.execute("SELECT * FROM student")
28 rows = cur.fetchall()
29 return rows
30
31 conn.close()
32
33 def delete(id):
34 conn = sqlite3.connect("student.db")
35 cur = conn.cursor()
36
37 cur.execute("DELETE FROM student WHERE id = ?", (id,))
38
39 conn.commit()
40 conn.close()
41
42 def update(id,name = " ", fname = " ", mname = " ", address = " ", mobno = " ", email = " ", dob = " ", gender = " "):
43 conn = sqlite3.connect("student.db")
44 cur = conn.cursor()
45
46 cur.execute("UPDATE student SET name = ? OR fname = ? OR mname = ? OR address = ? OR mobno = ? OR email = ? OR dob = ? OR gender = ?", \
47 (name, fname, mname, address , mobno, email, dob, gender))
48
49 conn.commit()
50 conn.close()
51
52 def search(name = " ", fname = " ", mname = " ", address = " ", mobno = " ", email = " ", dob = " ", gender = " "):
53 conn = sqlite3.connect("student.db")
54 cur = conn.cursor()
55
56 cur.execute("SELECT * FROM student WHERE name = ? OR fname = ? OR mname = ? OR address = ? OR mobno = ? OR email = ? OR dob = ? \
57 OR gender = ?", (name, fname, mname, address , mobno, email, dob, gender))
58 rows = cur.fetchall()
59 return rows
60
61 conn.close()
62
63
64 connect()
65